alter table Customers add
  CustomerTypeId int not null default (1),
  constraint Customers_CustomerTypes foreign key(CustomerTypeId) references CustomerTypes(Id)
go